home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d12
/
v9n19.arc
/
FIELDLEN.PRG
< prev
next >
Wrap
Text File
|
1990-10-13
|
948b
|
45 lines
* FIELDLEN.PRG - MAX LENGTH OF CHARACTER VARIABLES - D. Chambless
* Modified to use arrays and accept the filename as a parameter
PARAMETER filename
SET TALK OFF
CLOSE DATABASES
SELECT 1
USE &filename
DIMENSION NAM_CVAR(100), LEN_CVAR(100)
COPY STRUCTURE EXTENDED TO TEMP
SELECT 2
USE TEMP
SET FILTER TO FIELD_TYPE = 'C'
GO TOP
NO_CVAR = 0
DO WHILE .NOT. EOF()
NO_CVAR = NO_CVAR + 1
NAM_CVAR(NO_CVAR) = TRIM(FIELD_NAME)
LEN_CVAR(NO_CVAR) = 0
SKIP
ENDDO VAR
TOO_MANY = NO_CVAR
SELECT 1
GO TOP
DO WHILE .NOT. EOF()
NO_CVAR = 0
DO WHILE NO_CVAR < TOO_MANY
NO_CVAR = NO_CVAR + 1
FIELD = NAM_CVAR(NO_CVAR)
LEN_CVAR(NO_CVAR) = MAX(LEN_CVAR(NO_CVAR), LEN(LTRIM(TRIM(&FIELD))))
ENDDO VAR
SKIP
ENDDO EOF
NO_CVAR = 0
DO WHILE NO_CVAR < TOO_MANY
NO_CVAR = NO_CVAR + 1
? NAM_CVAR(NO_CVAR), STR(LEN_CVAR(NO_CVAR),5)
ENDDO VAR
CLOSE DATABASES
ERASE TEMP.DBF
RETURN